﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'operarioUpdate')
	BEGIN
		DROP  Procedure  operarioUpdate
	END
GO

CREATE PROCEDURE [dbo].[operarioUpdate] 	
	(	
		@id AS INT,
		@nombre AS VARCHAR(50),
		@puesto_id AS INT,
		@costo_hora AS MONEY
	)	
AS
BEGIN	
	SET NOCOUNT ON
	  
	UPDATE	Lit_Operario
	SET		Nombre = @nombre,
			PuestoId = @puesto_id,
			CostoxHora = @costo_hora
	WHERE id = @id
	
	SET NOCOUNT OFF
END
GO
 